<?php
class Pagemanager_Data_Getallpages implements Pagemanager_Data_Mainable{
    
    private $core_controller_selectdata;
    
    public function __construct() {
        $this->core_controller_selectdata = new Core_Controller_Selectdata;
    }
    
    public function main(array $variables = null) {
        $variables['query'] = "SELECT page_settings.page_name, page_content_values.page_title, page_meta_values.page_meta_description, page_meta_values.page_meta_keywords, page_content_values.page_creation_date FROM page_settings, page_meta_values, page_content_values WHERE page_settings.page_name = page_meta_values.page_name AND page_settings.page_name = page_content_values.page_name AND page_content_values.page_name = page_meta_values.page_name ORDER BY page_content_values.page_creation_date ASC;";
        //echo $variables['query'];
        //die();
        return $this->core_controller_selectdata->main($variables);
    }

}
